select org.LOGIN_NAME , ctp.id affriaId,col.id summaryId,ctp.MEMBER_ID memberId
 from col_summary col
left join ctp_affair ctp on col.FORM_RECORDID=ctp.FORM_RECORDID
left join ORG_PRINCIPAL org on org.member_Id=ctp.member_id
left join formmain_0043 fm on fm.id=col.FORM_RECORDID
where  ctp.STATE=3 and fm.field0101='${EBELN}'